home *** CD-ROM | disk | FTP | other *** search
/ mail.altrad.com / 2015.02.mail.altrad.com.tar / mail.altrad.com / TEST / office deutch / ACCESS.NL-NL / ACCLR.CAB / ACCESS_TEMPLATE_ASSETS.ACCDT_1043 / template / database / objects / queryContactsExtendedAddFurigana.txt < prev    next >
Text File  |  2006-11-12  |  5KB  |  112 lines
  1. ∩╗┐Operation =1
  2. Option =0
  3. Begin InputTables
  4.     Name ="Contacts"
  5. End
  6. Begin OutputColumns
  7.     Alias ="File As"
  8.     Expression ="IIf(IsNull([Last Name Furigana]),IIf(IsNull([First Name Furigana]),[Company Furigana],[First Name Furigana]),IIf(IsNull([First Name Furigana]),[Last Name Furigana],[Last Name Furigana] & \" \" & [First Name Furigana]))"
  9.     Alias ="Contact Name"
  10.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  11.     Expression ="Contacts.*"
  12. End
  13. Begin OrderBy
  14.     Expression ="IIf(IsNull([Last Name Furigana]),IIf(IsNull([First Name Furigana]),[Company Furigana],[First Name Furigana]),IIf(IsNull([First Name Furigana]),[Last Name Furigana],[Last Name Furigana] & \" \" & [First Name Furigana]))"
  15.     Flag =0
  16.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  17.     Flag =0
  18. End
  19. dbBoolean "ReturnsRecords" ="-1"
  20. dbInteger "ODBCTimeout" ="60"
  21. dbByte "RecordsetType" ="0"
  22. dbBoolean "OrderByOn" ="0"
  23. dbByte "Orientation" ="0"
  24. dbByte "DefaultView" ="2"
  25. dbBoolean "FilterOnLoad" ="0"
  26. dbBoolean "OrderByOnLoad" ="-1"
  27. dbBoolean "TotalsRow" ="0"
  28. dbBinary "GUID" = Begin
  29.     0x5195dfa1f2d4f64e8b3e0000494ae398
  30. End
  31. dbLongBinary "DOL" = Begin
  32.     0x0acc0e55000000004802068f71449c44a9f2c03f36ec4a3f000000002bffe443 ,
  33.     0x570ae340010000004029283443006f006e007400610063007400730000000000 ,
  34.     0x0000ec96e6af686f0441b0e2672fb8bb10fd070000005195dfa1f2d4f64e8b3e ,
  35.     0x0000494ae398460069006c0065002000410073000000000000000b8c708367ec ,
  36.     0x4446bc18bd8854c6e514070000005195dfa1f2d4f64e8b3e0000494ae3984300 ,
  37.     0x6f006e00740061006300740020004e0061006d0065000000000000005e70b4fa ,
  38.     0x1c446b4097a6867289505780070000004802068f71449c44a9f2c03f36ec4a3f ,
  39.     0x4c0061007300740020004e0061006d0065000000000000003e8d3bb15292dd4e ,
  40.     0xb10a1776b3854c3b070000004802068f71449c44a9f2c03f36ec4a3f46006900 ,
  41.     0x72007300740020004e0061006d0065000000000000003919900d9b336b43b5d2 ,
  42.     0x650bb6bdf187070000004802068f71449c44a9f2c03f36ec4a3f43006f006d00 ,
  43.     0x700061006e007900000000000000000000000000000000000000000000000c00 ,
  44.     0x0000040000000000000000000000000000000000 ,
  45.     0x0acc0e55000000004802068f71449c44a9f2c03f36ec4a3f000000004dfbfa41 ,
  46.     0x570ae340010000004029283443006f006e007400610063007400730000000000 ,
  47.     0x00000159828ffa61da46a83a5f48132bf0c607000000692a448ad6c75541874e ,
  48.     0x9804074b4c34460069006c0065002000410073000000000000008e4a07814394 ,
  49.     0x884498df3c7413cc50a807000000692a448ad6c75541874e9804074b4c344300 ,
  50.     0x6f006e00740061006300740020004e0061006d0065000000000000006b32cfd2 ,
  51.     0x00d1204cb3109850a53a80f1070000004802068f71449c44a9f2c03f36ec4a3f ,
  52.     0x4c0061007300740020004e0061006d0065002000460075007200690067006100 ,
  53.     0x6e006100000000000000862f68d6655d6e4fafd4286f0abd7236070000004802 ,
  54.     0x068f71449c44a9f2c03f36ec4a3f4600690072007300740020004e0061006d00 ,
  55.     0x650020004600750072006900670061006e006100000000000000c44b5d53328f ,
  56.     0x1c4cb6cd1541caad69c3070000004802068f71449c44a9f2c03f36ec4a3f4300 ,
  57.     0x6f006d00700061006e00790020004600750072006900670061006e0061000000 ,
  58.     0x000000005e70b4fa1c446b4097a6867289505780070000004802068f71449c44 ,
  59.     0xa9f2c03f36ec4a3f4c0061007300740020004e0061006d006500000000000000 ,
  60.     0x3e8d3bb15292dd4eb10a1776b3854c3b070000004802068f71449c44a9f2c03f ,
  61.     0x36ec4a3f4600690072007300740020004e0061006d0065000000000000003919 ,
  62.     0x900d9b336b43b5d2650bb6bdf187070000004802068f71449c44a9f2c03f36ec ,
  63.     0x4a3f43006f006d00700061006e00790000000000000000000000000000000000 ,
  64.     0x0000000000000c000000040000000000000000000000000000000000
  65. End
  66. Begin
  67.     Begin
  68.         dbText "Name" ="Contact Name"
  69.         dbInteger "ColumnWidth" ="1695"
  70.         dbInteger "ColumnOrder" ="1"
  71.         dbBoolean "ColumnHidden" ="0"
  72.         dbMemo "SmartTags" ="\"urn:schemas-microsoft-com:office:smarttags#PersonName\""
  73.         dbLong "AggregateType" ="-1"
  74.         dbBinary "GUID" = Begin
  75.             0x0b8c708367ec4446bc18bd8854c6e514
  76.         End
  77.     End
  78.     Begin
  79.         dbText "Name" ="File As"
  80.         dbInteger "ColumnWidth" ="1695"
  81.         dbInteger "ColumnOrder" ="2"
  82.         dbBoolean "ColumnHidden" ="0"
  83.         dbLong "AggregateType" ="-1"
  84.         dbBinary "GUID" = Begin
  85.             0xec96e6af686f0441b0e2672fb8bb10fd
  86.         End
  87.     End
  88. End
  89. Begin
  90.     State =0
  91.     Left =0
  92.     Top =0
  93.     Right =799
  94.     Bottom =612
  95.     Left =-1
  96.     Top =-1
  97.     Right =784
  98.     Bottom =268
  99.     Left =0
  100.     Top =0
  101.     ColumnsShown =539
  102.     Begin
  103.         Left =48
  104.         Top =12
  105.         Right =192
  106.         Bottom =156
  107.         Top =0
  108.         Name ="Contacts"
  109.         Name =""
  110.     End
  111. End
  112.